package com.gufe.mapper.admin.datascreen;

import com.gufe.service.admin.impl.datascreen.LeftChartServiceImpl;
import com.gufe.vo.datascreen.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface LeftChartMapper {

    List<LeftTopChartVO> getLeftTopChartData();

    List<Integer> getPreReserveByAge(Integer[] ages);

    List<Integer> getClubByAge(Integer[] ages);

    List<PieChartVO> getManHeight();

    List<PieChartVO> getWomanHeight();

    List<PieChartVO> getWeight();

    List<LeftTopMainChartVO> getLeftTopMainChartData();

    List<Integer> getMalePreReserveByAge(Integer[] ages);

    List<Integer> getFemalePreReserveByAge(Integer[] ages);

    List<Integer> getClubMalePreReserveByAge(Integer[] ages);

    List<Integer> getClubFemalePreReserveByAge(Integer[] ages);

    List<LeftBottomMainChartPieChartVO> getPieData();

    List<Integer> getBarData(Integer gender);

    List<Integer> getLineChartData(Integer gender);

    @Select("SELECT COUNT(*) from precollect_members;")
    Integer getTotalClub();

    @Select("SELECT Count(*) from basic_info")
    Integer getTotalReserve();

    @Select("SELECT Count(*) from army_member")
    Integer getTotalJoinArmy();
}
